1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Views
12 {
13 public partial class uctThucDon : UserControl
14 {
15 public uctThucDon()
16 {
17 InitializeComponent();
18 }
19 public static uctThucDon uctTD = new uctThucDon();
20 int flag = 0;
21 private void uctThucDon_Load(object sender, EventArgs e)
22 {
23 HienThiDanhSachTD();
24 bingding();
25 dis_end(false);
26 }
27 public void HienThiDanhSachTD()
28 {
29 dgvDanhsachTD.DataSource = Models.ThucDonMod.FillDataSetThucDon().Tables[0];
30 dgvDanhsachTD.RowHeadersVisible = false;
31 dgvDanhsachTD.BorderStyle = BorderStyle.Fixed3D;
32 }
33 void bingding()
34 {
35 txtIdTD.DataBindings.Clear();
36 txtIdTD.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "IdThucDon");
37 cmbTenLTD.DataBindings.Clear();
38 cmbTenLTD.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "TenLoaiThucDon");
39 txtTenTD.DataBindings.Clear();
40 txtTenTD.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "TenThucDon");
41 txtDonvitinh.DataBindings.Clear();
42 txtDonvitinh.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "DonViTinh");
43 txtSoluongton.DataBindings.Clear();
44 txtSoluongton.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "SoLuongTon");
45 txtDongiaton.DataBindings.Clear();
46 txtDongiaton.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "DonGiaTon");
47 txtTontoithieu.DataBindings.Clear();
48 txtTontoithieu.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "TonToiThieu");
49 cmbTrangthai.DataBindings.Clear();
50 cmbTrangthai.DataBindings.Add("Text", dgvDanhsachTD.DataSource, "TrangThai");
51 }
52 void loadcontrol()
53 {
54 cmbTrangthai.Items.Clear();
55 cmbTrangthai.Items.Add("Còn hàng");
56 cmbTrangthai.Items.Add("Đã hết");
57 cmbTenLTD.DataSource = Models.LoaiThucDonMod.FillDataSet_getTenLoaiThucDon().Tables[0];
58 cmbTenLTD.DisplayMember = "TenLoaiThucDon";
59 //cmbTenLTD.ValueMember = "IdLoaiThucDon";
60
61 }
62 void clearData()
63 {
64 txtIdTD.Text = Models.connection.ExcuteScalar(String.Format("select IdThucDon= dbo.fcgetIdThucDon()"));
65 txtTenTD.Text = "";
66 txtDonvitinh.Text = "";
67 txtSoluongton.Text = "";
68 txtDongiaton.Text = "";
69 txtTontoithieu.Text = "";
70 loadcontrol();
71 }
72 void dis_end(bool e)
73 {
74 cmbTenLTD.Enabled = e;
75 txtTenTD.Enabled = e;
76 txtDonvitinh.Enabled = e;
77 txtSoluongton.Enabled = e;
78 txtDongiaton.Enabled = e;
79 txtTontoithieu.Enabled = e;
80 cmbTrangthai.Enabled = e;
81 btnLuu.Enabled = e;
82 btnHuy.Enabled = e;
83 btnThemMoi.Enabled = !e;
84 btnXoa.Enabled = !e;
85 btnSua.Enabled = !e;
86 }
87
88 private void btnThemMoi_Click(object sender, EventArgs e)
89 {
90 flag = 0;
91 clearData();
92 dis_end(true);
93 }
94
95 private void btnHuy_Click(object sender, EventArgs e)
96 {
97 uctThucDon_Load(sender, e);
98 dis_end(false);
99 }
100
101 private void btnLuu_Click(object sender, EventArgs e)
102 {
103 string _idTD = "";
104 try
105 {
106 _idTD = txtIdTD.Text;
107 }
108 catch { }
109 string _tenLTD = "";
110 try
111 {
112 _tenLTD = cmbTenLTD.Text;
113 }
114 catch { }
115 string _tenThucDon = "";
116 try
117 {
118 _tenThucDon = txtTenTD.Text;
119 }
120 catch { }
121 string _donViTinh = "";
122 try
123 {
124 _donViTinh = txtDonvitinh.Text;
125 }
126 catch { }
127 float _soLuongTon = 0;
128 try
129 {
130 _soLuongTon = Convert.ToInt32(txtSoluongton.Text);
131 }
132 catch { }
133 float _donGiaTon = 0;
134 try
135 {
136 _donGiaTon = Convert.ToInt32(txtDongiaton.Text);
137 }
138 catch { }
139 float _tonToiThieu = 0;
140 try
141 {
142 _tonToiThieu = Convert.ToInt32(txtTontoithieu.Text);
143 }
144 catch { }
145 string _trangThai = "";
146 try
147 {
148 _trangThai = cmbTrangthai.Text;
149 }
150 catch { }
151 if (flag == 0)
152 {
153
154
155 if (_tenThucDon == "")
156 MessageBox.Show("Hãy nhập tên thực đơn");
157 else
158 {
159 int i = 0;
160 i = Controllers.ThucDonCtrl.InsertThucDon(_idTD, _tenLTD,_tenThucDon,_donViTinh,_soLuongTon,_donGiaTon,_tonToiThieu,_trangThai);
161 if (i > 0)
162 {
163 MessageBox.Show("Thêm mới thành công");
164 HienThiDanhSachTD();
165 }
166 else
167 MessageBox.Show("Thêm mới không thành công");
168 }
169 }
170 else
171 {
172 int i = 0;
173 i = Controllers.ThucDonCtrl.UpdateThucDon(_idTD, _tenLTD, _tenThucDon, _donViTinh, _soLuongTon, _donGiaTon, _tonToiThieu, _trangThai);
174 if (i > 0)
175 {
176 MessageBox.Show(" Sửa thành công");
177 HienThiDanhSachTD();
178 uctThucDon_Load(sender, e);
179 }
180 else
181 MessageBox.Show("Sửa không thành công");
182 }
183 uctThucDon_Load(sender, e);
184 }
185
186 private void btnSua_Click(object sender, EventArgs e)
187 {
188 flag = 1;
189 dis_end(true);
190 loadcontrol();
191 }
192
193 private void btnXoa_Click(object sender, EventArgs e)
194 {
195 string _idTD = "";
196 try
197 {
198 _idTD = txtIdTD.Text;
199 }
200 catch { }
201 DialogResult dr = MessageBox.Show("Bạn có chắc chắn xóa ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
202 if (dr == DialogResult.Yes)
203 {
204 int i = 0;
205 i = Controllers.ThucDonCtrl.DeleteThucDon(_idTD);
206 if (i > 0)
207 {
208 MessageBox.Show(" Xóa thành công");
209 HienThiDanhSachTD();
210 uctThucDon_Load(sender, e);
211 }
212 else
213 MessageBox.Show("Xóa không thành công");
214 }
215 else
216 return;
217 }
218 }
219 }